Converts a number to its textual representation. This function is useful with table tasks, such as creating charts, where you don't want a number included in a calculation.
Format: NUMTOTEXT (number)
Argument:
ΓÇó number: a number, cell reference that contains a number, or field name that contains a number.
Example:
NUMTOTEXT (1992) returns 1992.
Shows that 1992, after being converted by NUMTOTEXT, is now interpreted as a label in the chart rather than being included as a part of the data series used to build the chart.